

CREATE TABLE [dbo].[AgentCashTransaction_Log](
	[InvoiceID_log] [bigint] NOT NULL,
	[InvoiceID] [bigint] NOT NULL,
	[InvoiceNo] [varchar](50) NOT NULL,
	[InvoiceDate] [datetime] NOT NULL,
	[DefaultBranchID] [bigint] NOT NULL,
	[CreatedBy] [bigint] NOT NULL,
	[ModifiedBy] [bigint] NOT NULL,
	[CreatedDate] [datetime] NOT NULL,
	[ModifiedDate] [datetime] NOT NULL,
	[AgentID] [bigint] NOT NULL,
	[AgentCode] [varchar](50) NOT NULL,
	[CurrencyID] [bigint] NOT NULL,
	[Rate] [decimal](18, 4) NOT NULL,
	[PaidAmount] [decimal](18, 4) NOT NULL,
	[BankID] [bigint] NULL,
	[BankCode] [varchar](50) NULL,
	[TransactionType] [tinyint] NOT NULL,
	[log_sysDate] [datetime] NOT NULL,
	[log_userid] [bigint] NOT NULL,
	[log_status] [tinyint] NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


